SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 348481 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 348481 [ RunTime:0.003374s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812189,746042,962060,1025596,621237,86186,643036,865564,489280,332184,867435,826003,997748,220394,496936,326501,331589,84158,148058,392653,918687,1010240,188780,147871,1012415,97281,410583,814939,200837,986822,446111,293483,133253,1003026,304692,681235,146881,189392,434904,368799,148804,314309,323900,6355,833238,1013481,991463,202942,636900,96750,170440,1005769,895889,471291,696985,440396,157775,274913,592540,958544) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001623s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 348481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 348481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003749s ]