SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040854 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040854 [ RunTime:0.001799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (915718,602858,261902,866431,308629,465072,270227,137484,272778,40993,790345,935815,715486,707892,250970,702194,321413,583534,736429,264005,509398,530801,352066,795857,478278,334743,749812,835864,390333,379520,907425,709828,962331,22823,867518,1037152,158804,727357,607618,117473,735962,490296,34639,495600,504768,250224,264478,773619,573232,526302,203703,292643,907213,964383,870310,105040,924187,118310,901869,1041997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040854 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040854 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]