SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512916 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512916 [ RunTime:0.003384s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105312,973646,411244,876115,413088,507258,525034,962943,768869,631362,226998,191193,434503,866776,880552,206310,43808,260159,242295,758580,724284,836359,84651,906747,230171,455992,306022,590126,847155,131969,705879,391616,76282,305947,374242,707446,637540,389222,810443,664491,1025932,40441,435331,7375,285846,673954,1009991,729167,671945,953893,637006,918464,384429,770719,309063,936667,807518,648244,83327,233572) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]