SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412881 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412881 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014296,118564,520056,224623,546095,987919,469118,625971,1040450,952628,257696,100704,325527,527626,715200,315911,1035665,762717,706024,763537,529707,680097,254481,853746,412400,212124,747671,178256,43555,613063,886540,546000,1003857,571897,119510,113631,487929,954086,150317,700608,675370,112319,466451,286472,485525,608143,72849,421448,538733,449279,972567,935600,1017009,736602,54436,215098,45774,93840,982007,581556) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]