SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20121 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20121 [ RunTime:0.001464s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (126061,137392,867604,292677,9705,426902,25682,167922,398243,767185,656971,368885,146465,161669,132524,86769,621132,1017809,899568,201070,579304,1010322,810217,777425,683547,229662,383023,1029512,172766,342847,37482,602064,382068,293517,830629,759924,123407,478339,169624,796306,986207,653201,812707,910890,1664,373196,903888,131807,317265,723619,214192,525501,176448,660696,281513,51035,806559,831609,317375,857218) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20121 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20121 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]