SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503252 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503252 [ RunTime:0.006166s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (721090,141346,338561,258643,87666,829272,39254,1501,1004663,493877,971166,132601,405135,956460,816162,420449,787028,376128,640612,696248,306652,373461,43505,1029980,766749,798508,697013,693316,510983,226831,100418,572976,689035,393260,19364,284941,69315,592552,684498,708099,994226,765464,47988,164274,964976,216546,806938,975001,496213,554072,927639,922493,653463,84312,1041656,966322,946256,162027,678835,930420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503252 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503252 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002705s ]