SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401213 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401213 [ RunTime:0.002637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (818672,393552,704657,925063,181031,289963,134729,293174,23425,818548,790160,858342,530529,122740,441027,735950,1012805,679929,832321,392170,483993,1028940,362513,849765,653105,482829,1004003,757210,748183,843427,230340,659252,902745,401376,57607,350725,156308,261502,737387,423835,443596,576923,672703,236751,725942,1039629,635676,418056,707772,831021,970631,723328,808057,17657,243194,49972,1044174,124292,452624,176931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000932s ]