SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103890 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103890 [ RunTime:0.002637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (963188,222130,24596,180760,724705,415423,121280,447026,402590,390044,609649,419683,753753,66192,1038517,118509,845828,143178,102573,374648,354892,578615,615213,770931,865179,203155,135422,1001886,148460,490094,449243,902601,66249,992372,447386,251626,772974,817342,381524,408457,526783,336529,666072,409165,1022346,696848,1002828,883149,166187,1020057,162417,361130,968761,853876,543233,139126,429503,756837,25104,187283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]