SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403670 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403670 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (195376,263541,224262,677136,179265,42093,912557,655525,387987,56664,635661,47269,239072,354872,538706,259072,888961,987352,397812,393874,615444,626563,707138,963357,94599,930189,619177,217080,1035286,164290,359815,394869,497365,723332,198573,16270,44847,197392,1023516,152096,52347,154841,336322,483253,195075,995791,415189,27937,628017,1025239,32193,534015,617194,325707,789408,672742,614983,777494,837178,882035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403670 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403670 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]