SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39366 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39366 [ RunTime:0.001474s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436669,119092,10546,209035,844183,521461,852618,635837,417017,587639,823178,18586,591507,137290,19699,299177,639390,272084,137588,429838,948212,119204,265512,204065,115947,112312,711494,944779,1001193,518215,63740,844748,40476,342447,6022,432920,64452,268244,285727,685660,855267,103091,594403,643009,768319,942696,145332,985984,289383,624365,313252,639644,915205,958512,232208,1015570,508901,151030,1023407,799579) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39366 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39366 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001872s ]