SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 701848 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 701848 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426035,750162,896248,814371,770259,936389,438969,457751,564579,965606,127677,634531,303087,631340,488824,295801,786022,352764,630074,311750,737212,391298,716864,282300,359946,142405,614719,245849,630638,956662,973357,823921,37128,222092,888447,1014071,614838,585121,881621,22642,385425,192739,217743,257318,346381,967875,610750,389857,1010944,1021544,927487,598502,505064,981930,1011038,864160,566349,1013643,831585,57478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 701848 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 701848 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]