SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534900 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534900 [ RunTime:0.002256s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (617628,13784,104390,121571,126775,103601,633520,2047,375393,629129,48155,389449,1028270,120986,172753,592065,982255,672716,128788,872627,421413,162384,385265,485913,20824,725217,1000218,183988,327676,626186,284369,87092,1028792,137446,319030,130894,832821,373540,338686,727200,834707,98885,311428,948431,881148,339765,490128,497055,362041,188535,142449,214304,823016,754856,468728,1021494,897052,764097,63367) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534900 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534900 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]