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` = 364031 LIMIT 1 [ RunTime:0.000528s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 364031 [ RunTime:0.004311s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (209681,544646,160505,275531,1017916,264278,828440,695674,786665,218493,144648,694999,143078,189387,807604,418749,992411,47244,886138,876753,1030424,1009787,991300,373816,432716,851609,124379,819834,178030,781370,192159,536586,773422,124007,963284,99894,844682,815344,566238,532206,886916,361500,197999,556301,662736,450151,483382,1042569,1040129,387470,55568,504964,918072,905631,215124,660223,574670,402576,471613,756641) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 364031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001788s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 364031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]