SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001709s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563682 LIMIT 1 [ RunTime:0.004452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563682 [ RunTime:0.001961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819800,385576,323530,884677,365471,447797,295655,200608,573093,566244,562856,145947,683307,156159,1010657,578385,743886,14290,940481,43038,505889,101993,706369,402060,880138,389191,407712,830789,724827,591057,455252,42985,1005808,138321,401803,1015739,301790,181606,877108,206544,406225,1034537,915335,148385,234536,822208,791446,409582,783230,217025,129243,892592,938979,478971,730944,826692,245519,674082,202015,856821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563682 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563682 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]