SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50549 LIMIT 1 [ RunTime:0.000520s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50549 [ RunTime:0.002100s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546105,138263,717206,248478,527155,118461,89064,812447,646973,204641,1025060,634356,769313,553796,890073,668000,394585,473053,140756,828714,45554,17264,735170,318953,234023,364772,710070,879911,248229,885133,19476,726203,325413,995121,237635,544842,370577,826510,693059,129115,588726,26058,649193,543847,717170,1029685,629272,189395,149405,162443,353545,528582,834128,367331,160601,398178,950271,279300,24334,1008156) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50549 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50549 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]