SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002023 LIMIT 1 [ RunTime:0.001384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002023 [ RunTime:0.002535s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434354,575965,462777,752917,134330,163812,421177,559191,857621,570565,721413,1022112,126365,453659,460896,221377,355909,339040,302284,948646,612186,954347,117618,801535,127990,517201,208384,447464,838148,337084,73406,156100,780048,457031,737386,8814,668955,940853,163486,184964,597516,125718,485453,357525,639987,316025,923926,638138,187701,376517,714278,817417,652750,302395,325381,1041693,671056,805928,150787,61836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]