SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405027 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405027 [ RunTime:0.002794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (239736,40781,401814,373373,714266,935864,568950,761717,811982,222144,976614,623219,705021,160219,333916,875726,567844,832209,11694,147235,372926,821642,760499,1040389,241034,1007115,220516,199249,832796,245873,66976,477657,1021349,701927,115589,456703,634840,169126,307245,735045,221191,369306,966995,393378,819311,982367,538863,239870,984851,870644,273815,565751,167259,661739,176257,907831,956737,108,821503,70511) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004046s ]