SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001495s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204633 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204633 [ RunTime:0.002047s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (195274,268488,59062,146964,298572,788003,314638,790802,995998,893621,724030,912221,61766,986896,89422,721558,167659,863358,213448,719217,507830,605066,920689,455467,569513,530333,356362,492233,276888,193074,826414,659782,529311,612236,419665,675123,767937,978297,918191,169659,240669,447046,192436,143742,343913,130084,810252,527901,228898,648622,994603,59587,971764,757460,383960,584432,847955,739986,378271,713351) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204633 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204633 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]