SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000924s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027301 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027301 [ RunTime:0.002634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505671,826208,847516,262343,1216,56053,705256,570641,15718,665226,625668,408174,646937,595473,297876,226860,836098,807480,562614,897492,745562,489175,345141,350569,439484,17580,580889,305229,277681,200252,360475,904397,293590,616796,35603,725254,1021997,274038,724476,821626,769134,474387,1000121,561501,154714,145002,358443,872727,564356,385910,116614,447177,426354,624432,1032973,607256,171308,767526,154762,525626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001798s ]