SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025175 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025175 [ RunTime:0.001562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (645820,591669,590146,590385,415951,636138,299643,834292,56313,60662,207230,187607,371309,61755,313433,270327,528995,315568,999725,33526,873680,944628,308913,568881,733394,505494,454528,449069,1040923,400138,252568,638654,202681,171885,984797,310945,26050,856639,908363,130594,210515,1021470,289991,491859,250716,212540,808159,801057,690775,786787,845548,885810,17682,333209,820892,33588,918482,334483,160662,401739) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025175 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025175 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000724s ]