SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402075 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402075 [ RunTime:0.001971s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180436,514398,1039750,395242,794307,1013556,42489,687638,1046897,826466,736843,777301,158151,449205,9425,707888,183180,440366,748289,927218,883069,794220,841552,793759,901361,789960,356416,822391,74069,378793,310093,1018295,867684,200126,82293,1036575,438079,906352,705338,311248,211261,384493,150509,483292,617104,550706,579682,397940,335939,500492,721400,982006,368974,532174,1001374,51018,678738,250246,228043,796164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]