SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545572 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545572 [ RunTime:0.002900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (692647,936371,148086,973791,579513,1002177,193447,121226,831073,989879,755966,328252,268250,847762,847760,189439,241206,909801,21816,1029911,90330,356078,108970,28968,819823,577120,1031766,353947,800671,964051,622050,804657,906806,467847,954898,9498,575684,705066,250785,289684,546257,901039,232218,519942,700154,733567,892083,533944,440291,476561,839335,484225,59345,982425,128640,790700,284979,34358,125799,515420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545572 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545572 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]