SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023808 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023808 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382170,571066,801914,943439,900183,1005382,374343,457374,685500,897746,100054,204625,666589,1023329,506574,889627,740005,716914,229444,299382,300454,402712,163099,131985,898386,32282,953784,327372,846525,496379,658203,239487,114232,11497,596212,651902,102004,479346,981921,484860,1010010,142710,15956,911862,753913,791244,520820,227560,270000,258543,708231,987180,675576,498423,768445,764706,489665,658632,519254,768326) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003742s ]