SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012239 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012239 [ RunTime:0.003835s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (990766,958604,376647,208952,273409,678656,71539,568942,853573,360605,905850,248176,931853,722108,111260,457619,50350,617698,752425,318507,148718,294760,808143,186408,64506,227232,368153,606768,443470,252134,268218,159125,815970,301256,254382,335256,830191,127420,415486,667848,948508,703669,93291,784379,16502,52941,977508,234551,89102,730349,1006080,813440,58635,429220,561536,783904,965961,41536,318158,294465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012239 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012239 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]