SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 571090 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 571090 [ RunTime:0.002141s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (176991,1038103,600132,205869,525116,778403,769612,791769,883774,969387,395725,180122,422451,845971,580996,260694,32142,956641,1025798,921534,252759,109597,312985,243194,786491,946855,37072,782857,687895,995404,420888,167682,474428,246368,935712,148801,259463,5948,220121,465527,806446,412261,15962,707868,717339,143176,968412,736259,316480,635419,296962,989775,878789,111818,591919,801967,524737,982142,897536,750953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 571090 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 571090 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]