SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 496815 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 496815 [ RunTime:0.002458s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (67912,280921,701387,803707,499715,1079,56871,538362,268192,11195,500081,636992,212304,812115,533280,860369,352917,961335,467073,722135,579497,902360,84810,670786,805816,559548,714008,438732,408888,735800,249866,314858,599366,738002,94856,157799,73434,818834,721917,117127,581964,624712,603884,9139,219302,388943,211034,328796,89448,355436,326795,942406,743122,1023231,31292,691068,609611,534464,398991,663903) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 496815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 496815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]