SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 619100 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 619100 [ RunTime:0.005019s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513505,870877,800877,482191,724391,169852,262783,939916,536147,1020450,278223,781386,492248,669548,177466,526228,686878,881374,606254,888917,117293,114200,280229,172592,623611,262734,390483,507403,331812,1046393,380375,1015793,1045045,734269,532715,41416,17735,199743,175871,727825,664628,861119,263092,252110,799786,596078,951317,465009,175326,820737,998587,685702,8614,910831,191791,552947,280763,104911,344378,103269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 619100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 619100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]