SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505643 LIMIT 1 [ RunTime:0.001070s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505643 [ RunTime:0.001250s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (598768,538257,182994,879090,743823,119463,232625,43887,682182,854129,111671,898869,35534,492408,829211,395004,288377,292831,114931,810165,785851,48517,165276,51987,414070,316313,58031,487733,269706,830508,701188,72724,885948,157887,683748,258153,729004,502163,336330,492626,996000,941313,154844,146062,266783,289018,680752,968108,672757,271004,980187,781632,1009674,408048,366307,772235,243708,250872,465898,200102) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002922s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]