SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405747 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405747 [ RunTime:0.001469s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620178,847726,748712,553634,399511,730989,399129,463079,99525,765692,178757,181465,6763,402692,105733,739179,36918,558039,73614,125000,280936,833493,572746,863020,214721,1026539,484128,369358,256918,792973,563095,348993,907324,775962,993049,517110,611351,578651,240582,654388,1019202,369870,830274,19147,818738,261114,1021702,258071,1043697,196776,845429,343331,868907,621965,952173,106165,148344,544324,886510,788193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405747 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405747 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]