SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54203 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54203 [ RunTime:0.001850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384545,66340,965700,399318,838554,584117,105639,421606,376969,415639,524885,896512,871809,534749,454467,838717,656199,903683,212031,345397,363637,249535,413620,252007,98376,920308,745352,319359,554397,211354,478968,367105,780003,463819,876041,738510,556945,307414,29164,880858,447850,271712,425194,551900,771083,660865,398818,316799,142601,112317,686548,722177,103106,937253,434591,1028916,214164,172822,241592,916154) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001396s ]