SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 323800 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 323800 [ RunTime:0.001738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18041,291254,92425,10388,569213,304176,616414,945847,545158,524781,995030,386969,531435,535815,654757,375835,260753,865140,881167,161428,683550,231703,441969,559008,685914,378173,488785,620032,789363,1044423,688832,640191,986051,421925,614966,114554,600489,788646,786625,178088,689056,533561,821443,341136,867338,941034,550399,469129,70313,187726,194922,260642,819056,575212,315631,569248,857910,142014,29463,380068) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 323800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 323800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002378s ]