SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50682 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50682 [ RunTime:0.003049s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (226516,830191,1029285,550360,719065,763586,687175,930857,941662,843212,327106,431069,395784,404560,255725,343050,358946,439323,1021366,985497,488284,17525,869939,867174,145661,222942,348003,530862,547049,616136,309451,148828,39249,769834,949272,1028513,711648,167461,178189,694230,845531,724314,262518,925305,443711,542655,17197,903819,394842,708160,73159,927628,423068,115348,185770,570405,873514,884388,751177,16775) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50682 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50682 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000688s ]