SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030600 LIMIT 1 [ RunTime:0.004094s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030600 [ RunTime:0.004647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (330628,915881,698435,681084,172665,300471,76003,562571,573856,528984,607173,508815,971212,203046,58476,413522,238425,670304,797471,72540,799981,330976,387788,521111,174706,711155,674141,92536,59346,543898,7747,783861,406791,119412,789210,418620,106691,94803,530606,121169,745073,106723,76608,698332,476828,884324,402090,155425,594198,855074,941654,171578,489460,736347,505280,551302,763264,202520,220126,451789) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030600 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030600 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000700s ]