SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019163 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019163 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (875719,351861,524250,121648,219323,799080,750137,295558,123636,829219,764541,404841,69571,1038064,322481,56902,742648,696113,862846,321502,136540,301358,396686,403034,426113,394642,993546,298968,459014,800713,1006721,524910,724905,856310,330925,1022413,540580,822193,720312,1008806,616360,245286,958137,644514,456811,700403,452560,734502,459368,626181,260676,673958,858896,597615,821447,720445,505337,672585,675560,138434) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019163 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019163 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]