SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402628 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402628 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (454147,1018101,151938,102921,290830,503118,675834,396657,911474,430969,939042,773302,767505,451512,5034,260646,926081,469963,491728,379656,229321,473509,190880,748306,483647,428182,10879,885088,366253,760270,592835,643324,412147,957925,905481,4842,249107,111987,4643,707784,765463,455008,280637,465162,776187,1029436,1007180,385883,690212,409272,637025,264537,764235,923089,616728,750828,114763,422352,395595,472906) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]