SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403600 LIMIT 1 [ RunTime:0.003802s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403600 [ RunTime:0.004601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (964210,371784,522735,864349,898391,1047071,749136,152167,486033,593005,329015,982995,371717,335753,127368,319649,914009,301467,323612,53869,171645,880189,709013,330650,614754,210835,110079,956576,30366,643894,94616,835083,54849,825601,462160,104289,938044,574214,525560,764892,29207,106995,862507,408551,976011,39085,560781,492591,499307,655107,598039,988730,561744,1005855,53857,586316,471798,378985,484952,389744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403600 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000670s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403600 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001531s ]