SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503930 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503930 [ RunTime:0.003591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (893111,66088,731065,902691,326712,256700,555153,878274,609160,612612,32881,689271,1047206,995837,171533,635981,591894,387828,16524,19249,673160,881384,552972,714947,655609,991307,428354,696977,633346,884469,587491,409654,478623,73883,476624,902585,334072,1015841,68458,90974,594878,459773,149709,759307,935339,699830,486140,418882,19513,301834,319425,142794,291739,270364,458890,965771,629721,650894,534383,691430) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503930 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503930 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]