SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 687291 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 687291 [ RunTime:0.004389s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (558764,354711,551190,16777,620949,751817,689464,269914,392670,298509,242824,413371,19828,952115,605938,543309,1022086,515416,993303,166506,147366,416305,888111,649227,760079,639836,393190,453157,890516,719512,582786,239354,474077,732905,121513,457263,783385,991484,8499,683377,40509,496601,537620,703259,37146,978990,164016,230473,330466,44538,182457,742995,1000650,155619,29136,748936,915699,832825,611086,894367) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 687291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 687291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]