SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002825s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404410 LIMIT 1 [ RunTime:0.000463s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404410 [ RunTime:0.002380s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (233392,348780,260002,141854,804622,89744,831419,586796,285936,461139,263450,471266,252153,600073,134518,706448,407588,866954,309882,629714,733117,176487,882715,288673,716766,17909,747716,165279,270338,1033904,614153,788695,136231,292096,785963,594829,226918,72862,766550,986186,247950,625428,689379,503968,698295,669355,1042951,921683,432113,442534,469966,498395,582939,804922,888857,571687,821054,325714,324762,263046) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001845s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000824s ]