SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514003 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514003 [ RunTime:0.003383s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619964,87188,391622,559161,672505,204016,125619,917945,973458,587089,635664,340539,201380,398195,420155,136939,266236,813746,938634,621579,158868,704509,563923,493912,232210,228431,133915,946005,901866,147494,506562,564602,464966,17968,774448,417842,921352,51022,182962,309783,1024572,381731,648964,809942,114205,1022326,534902,1001387,964132,883572,997906,143296,372987,337076,411525,151941,679376,801946,456159,960049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]