SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003586s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105618 LIMIT 1 [ RunTime:0.004723s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105618 [ RunTime:0.005748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (975716,617915,749352,478544,784562,245811,954867,620612,638838,278929,1003291,1002063,714366,575383,279203,317157,154664,892583,592570,508470,999213,919088,676370,803778,378668,424611,404764,594914,425496,482741,199524,92427,442914,775346,762756,162909,730564,71712,767724,120722,358159,1035160,458321,621420,235299,709522,158232,42257,364012,133360,489549,1038298,853150,865623,758537,726357,100606,534874,622314,967261) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001681s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000410s ]