SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001557s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 211161 LIMIT 1 [ RunTime:0.000459s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 211161 [ RunTime:0.002998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286873,939790,113496,576160,900475,248771,557161,119080,1045164,728275,296761,459548,699025,635301,365428,1016717,814764,93550,700147,717250,461079,344440,473957,305881,462470,394372,570686,827652,603056,838809,901770,126935,588490,382226,487686,746038,473228,129374,889333,218845,835262,385380,238510,696588,193158,1009192,746470,827209,81056,279974,331528,408196,927859,955194,901523,616390,977430,818461,256105,687494) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 211161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 211161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002072s ]