SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003410s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412001 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412001 [ RunTime:0.002867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (876976,745691,391417,965980,1003512,745252,106572,36523,135577,899552,1007970,80993,653074,977793,509715,303521,415427,324961,298908,543132,528069,1004745,134070,995061,192192,618045,296204,33776,639480,384713,589065,65547,326719,843332,272008,528593,57330,79246,425733,150452,99271,689838,223757,756362,602241,160417,252370,457922,339387,818615,648655,449792,1048257,211641,188698,927466,729549,627544,714336,668297) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000917s ]