SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540524 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540524 [ RunTime:0.001412s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596239,954044,1046696,52603,446250,212764,808694,413928,81357,792323,517352,400440,959906,459934,613413,410263,160511,971164,710751,643046,405347,882077,7521,1093,808583,616018,341636,507280,746623,926935,953765,367399,342361,428915,746811,441380,678032,796293,228365,105367,224468,303282,417840,206710,577067,446453,407670,595635,935000,986297,1045829,130744,73058,352242,277657,576680,203290,509420,500239,847721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000934s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540524 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540524 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]