SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001579s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311058 LIMIT 1 [ RunTime:0.001276s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311058 [ RunTime:0.001725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540572,758893,500440,311867,991499,833264,981798,760708,401113,532020,322516,703211,1041502,837487,986165,537138,551826,949335,617788,363896,929107,828971,784326,311964,1017629,209410,918378,243155,736446,357906,203738,215130,94730,1010641,419303,537170,362678,503442,1022342,621717,212660,423953,625355,116026,381851,996117,42306,865718,879651,195042,703288,349423,357456,959234,417027,507790,539825,179983,21524,185662) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.037453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311058 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311058 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003726s ]