SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102308 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102308 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (134396,88973,423237,106495,640176,227063,476098,232356,266922,793726,882977,570523,268712,775241,816012,167445,669954,331337,416787,217931,902540,905506,700777,315020,301415,472732,943056,606520,197523,508789,809581,853065,457755,561217,300491,782207,138726,333766,903896,937866,298191,521464,893245,144616,902107,448959,405861,399906,773102,814338,988445,584814,68340,1013262,802831,291154,680095,248013,981395,334371) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004186s ]