SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1008075 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1008075 [ RunTime:0.001411s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (997911,439834,80610,196317,641645,592679,11462,997703,344051,269811,460583,935092,550169,229588,902769,915659,428346,314760,56,104941,914879,334801,448250,318028,964096,887000,209097,1042873,821130,871539,763351,80084,435152,978624,167517,508868,93992,469560,935065,928760,62486,269713,299625,557827,356424,108977,761547,211598,341191,242019,431640,1031119,932661,290753,298804,993839,825336,262854,814430,801809) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000916s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1008075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1008075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000406s ]