SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458215 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458215 [ RunTime:0.001848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023185,944943,800496,659497,149001,397543,176190,35953,185670,582654,671201,70174,758671,145152,556596,531180,670800,1037549,364871,47961,737605,382490,287317,989945,883181,526905,54648,621307,965678,775446,1027011,428454,59950,588268,182131,317877,842561,861956,706246,724389,262498,98640,728893,38166,816629,171962,454047,915162,106237,677711,687111,517110,815946,661579,525725,277510,645118,607913,641473,305751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]