SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 811343 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 811343 [ RunTime:0.002825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802577,500780,9226,928904,772357,86573,833764,436298,754904,796876,299314,325059,936158,69356,466209,444301,132168,460119,303093,266898,674346,959147,386319,406747,856435,880573,810205,96050,19429,806928,210083,173982,973872,273928,444376,28722,995310,543240,351003,36483,542959,896197,860607,42979,275894,764459,212313,791927,44678,83681,335391,859367,698030,404273,813964,488164,382239,883017,564541,748620) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 811343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 811343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]