SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541756 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541756 [ RunTime:0.001556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119065,525263,203428,217764,923470,210546,528239,32080,634754,427858,1037175,764864,900386,217388,144661,66939,75450,622714,278773,486649,637496,572695,535862,956147,312447,549291,917933,443443,393446,204102,1035965,141354,748292,278345,899722,554032,395081,373378,420589,592767,166799,970971,152359,674482,929585,392145,637149,697071,83999,450760,1030637,358388,250764,262052,1026436,559279,1000338,1023714,372405,1038776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541756 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541756 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000752s ]