SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501861 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501861 [ RunTime:0.002376s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (322100,86696,652466,815408,846346,464863,814790,979071,589482,371668,70489,715495,362631,598147,403985,447427,843282,5417,439388,295460,272492,665594,431685,664505,47864,310160,370522,485438,412666,326513,664008,724729,249343,293687,553388,688750,638165,229862,666756,280952,164769,340282,272308,891660,820326,927088,106726,1041288,701028,252294,919374,239991,865658,963001,454466,452557,862519,380390,1041376,1010318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501861 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501861 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000722s ]