SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461851 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461851 [ RunTime:0.002081s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (190496,962181,868623,904725,681726,530049,489421,639619,726345,344231,508046,1007368,1021819,366843,448581,38124,686894,215052,81697,994977,710507,834945,578212,102061,155635,804389,700772,1995,358356,696013,476762,402233,682620,185944,689837,935603,776066,500447,563404,823846,813043,257139,780387,775341,1044882,599854,427805,303121,98363,770149,872630,901648,463020,1039161,146616,251584,928335,250650,893614,79799) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]