SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001872s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046889 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046889 [ RunTime:0.001881s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440344,585927,826058,635912,937325,780716,609971,885793,781913,869079,396746,114899,256299,511433,866091,373898,844612,616682,340158,841830,15769,241153,427525,18322,899413,641375,400527,719732,253887,532900,475538,40501,993030,586763,900214,57550,866261,651629,265894,761001,259388,1014583,171492,803377,930717,338541,747405,490006,219022,424107,891575,338301,236701,471969,490351,541734,147345,596621,454514,772596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046889 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046889 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]