SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445894 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445894 [ RunTime:0.007445s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281541,939619,235048,764872,854668,919733,278028,892874,600242,225944,377906,364183,188852,442600,942985,654394,483708,641654,547746,806505,21030,1021406,845339,246059,543624,900229,722572,734802,724902,820598,788593,1000741,14257,392459,699601,720192,582142,48229,539361,841652,60355,148333,944499,189550,710966,749474,317863,578825,146608,236909,387680,1017472,48987,931002,237702,475677,121961,525455,883776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000617s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000758s ]