SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034005 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034005 [ RunTime:0.003589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599189,354135,284159,106853,556611,336119,143757,607865,174772,300840,968415,619600,491554,988559,976436,556040,214866,1035912,171659,122780,486637,307610,252289,629074,970624,904171,635461,628017,32481,763798,403723,602444,13398,576883,355955,551723,463124,27454,854038,131615,456859,740531,754099,775554,649380,256760,388731,428792,191186,1028346,455960,628053,441514,29577,908515,193543,577218,677738,989082,315224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]