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` = 505141 LIMIT 1 [ RunTime:0.001228s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505141 [ RunTime:0.001738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (618620,285754,255448,11503,497565,746796,170375,761863,487199,718635,19641,429335,950542,431930,684140,71328,406101,667469,893402,996149,831749,607708,383770,844622,615587,383845,137662,121542,366290,30280,900412,122743,1030141,160205,1029458,423303,643763,847243,1000328,427218,163730,994819,589722,602973,106373,873739,303709,873398,575057,675242,137039,496042,168101,694283,420966,537560,1017605,104556,62316,977215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001494s ]