SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566000 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566000 [ RunTime:0.001815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580385,765734,887999,255693,582204,710694,647647,318163,609532,378360,563964,490160,335192,358635,603046,1013413,192626,209514,845538,215694,582659,172093,274167,36142,181910,974349,525132,176044,767854,110604,271832,674376,90323,930777,671262,744242,453103,715332,769235,394033,705401,827582,329433,738396,477088,529013,565970,343718,375497,1012223,528612,160566,827051,239886,566346,450893,650887,779980,365284,117728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566000 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566000 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000787s ]