SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004791s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416455 LIMIT 1 [ RunTime:0.002961s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416455 [ RunTime:0.008729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536345,556660,521806,671008,169139,396242,167080,769597,666682,89574,508900,407320,365881,397373,1030487,399072,861387,483190,952652,1014238,924615,222133,695420,521016,916309,669456,1036216,273182,162588,142567,574940,1003121,1028039,232752,933632,412039,629926,494402,606034,267992,474401,361725,360897,158483,691471,573739,976432,704663,64365,334098,665524,711075,64124,549534,1005821,634199,903893,122471,118285,1029190) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001572s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416455 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416455 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002148s ]