SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10389 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10389 [ RunTime:0.002738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (756750,477514,944051,429521,120046,882433,676015,931329,270560,246001,689280,16107,855775,487742,553798,638190,1039135,131742,678931,598869,790844,974860,739409,235151,208706,103677,305204,696988,318835,691799,530483,304056,350859,418888,439505,972758,414591,5291,279852,77578,191469,322088,920910,554189,432506,344664,703469,503127,63341,372290,26141,293317,885862,446347,1048248,948374,922764,642736,882494,504471) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10389 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10389 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]