SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009213 LIMIT 1 [ RunTime:0.000479s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009213 [ RunTime:0.002104s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (776417,373730,212208,90678,146012,354775,376594,7142,343535,110185,62543,198485,40410,872268,562727,825040,214413,297336,863393,480808,907999,637569,529576,1016847,637461,1019045,935805,1021480,342451,81063,556717,299883,913635,291684,865643,396456,1032672,123844,421519,431731,347103,80883,86078,161495,1041830,822983,862076,494669,423137,542052,857570,109481,744590,144418,91726,109275,681284,869985,800939,881191) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]