SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003521s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 441422 LIMIT 1 [ RunTime:0.001587s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 441422 [ RunTime:0.003158s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (736101,69663,217172,307103,598660,719464,1000392,444150,334778,250064,635624,406961,329943,115804,564523,740475,434843,46400,997685,725986,743226,352361,98363,682651,56301,709939,655122,9074,687269,564678,524498,1035776,650562,1027875,349662,842817,646166,284505,484339,452130,610793,283987,18647,306258,997484,741220,807320,204381,535182,1004103,92890,780201,985096,621638,880077,92663,83007,1009757,175966,625431) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 441422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 441422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]