SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014637 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014637 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194156,152352,185714,536961,757677,659116,45306,619379,435984,595160,656618,940276,946175,368011,46807,886110,959501,914981,1034120,187765,270437,694318,670228,249931,690288,33954,632483,396389,520567,338625,928989,803237,501082,105115,889762,310115,891848,441939,1027550,58431,133185,165854,675181,599773,926453,75704,288735,458421,809067,901994,728784,803393,579769,546081,768554,552587,251202,950082,110788,135067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014637 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014637 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000669s ]