SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540535 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540535 [ RunTime:0.002147s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (160124,71426,254889,61501,914567,367538,303020,954794,210016,843323,2414,1035221,749407,409111,856080,208945,947797,1034831,649429,51636,375312,245505,681419,429715,715116,188868,531354,669567,412405,860936,910752,144976,845916,514611,253133,228688,613093,435148,958943,548801,140602,128533,531563,896788,149597,688092,821054,341919,51446,22696,874815,338778,426468,413450,386824,332500,715074,450427,930027,776606) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000921s ]