SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518571 LIMIT 1 [ RunTime:0.001256s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518571 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042273,377955,683309,1010585,733555,706989,224319,29229,347666,211553,50051,230970,982752,275901,242623,83748,962897,544658,306716,1019937,752148,664271,700371,379220,886561,651842,599888,380258,366391,923095,462110,693452,714215,4917,148794,312097,952773,125919,835957,148262,941012,546109,578044,126180,566698,359825,883767,792658,627489,807191,430613,16939,341613,910454,589137,688728,429606,882681,512606,356785) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001343s ]