SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533078 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533078 [ RunTime:0.001807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801227,543065,521976,660357,578601,943333,40840,779549,954840,180673,359742,330480,702933,539764,578434,394082,857607,528180,432009,234846,935189,296451,37980,363305,128877,57064,232230,665906,91220,640516,1021853,1036631,1019933,470764,822477,183148,510367,146126,893907,818982,577391,742918,557206,335292,737363,546300,901386,905226,348185,1030095,663585,675907,883770,507649,735989,137057,534998,930722,886616,121506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]