SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548268 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548268 [ RunTime:0.001739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007696,19529,532673,425926,450426,803984,703662,522102,100500,704959,514837,59876,278578,252508,478500,287234,71336,505817,270259,945664,621139,1016771,406027,309123,347223,812973,726397,793807,557874,67446,861603,81621,604718,1036804,666257,60222,32153,216786,108125,234164,819729,1011563,189393,870847,625391,591704,435225,602915,1047271,741166,97688,913159,659932,256882,349036,104948,365696,377646,900955,347631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548268 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548268 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]