SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102806 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102806 [ RunTime:0.001732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314446,755011,748503,871199,775332,312101,936197,289109,716636,1038938,765063,1018985,351984,377604,400061,908057,673608,654791,422324,703278,425683,432341,927514,757539,579955,635403,565707,595793,847302,1027860,238075,665683,958545,66203,734276,847555,346307,121209,890228,502597,552663,591924,300648,588125,417514,639314,709754,493306,525037,546579,787916,287478,158463,223655,268,550698,820734,1005728,974010,455679) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]