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` = 991801 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 991801 [ RunTime:0.002105s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (611088,1006512,838753,933913,152313,740664,618260,978855,589363,335659,58834,261661,545763,170989,34274,406636,454966,82010,1015691,871498,621419,671553,99460,422391,708499,124111,1038328,141600,59089,730853,493943,67719,1017106,514784,1002720,81886,40662,454126,938952,456608,1011849,690450,70197,401281,533906,666660,620466,580347,35936,121220,799269,218122,716204,488447,935311,440098,334116,637410,545571,87555) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 991801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 991801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000717s ]