SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 250704 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 250704 [ RunTime:0.002384s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (129734,541791,452841,894409,480800,1036474,212381,537606,755146,771573,630198,358660,605305,145036,773273,209111,41997,180652,930326,322491,487543,606256,560591,557717,643546,263468,332769,572130,641805,808177,868691,49974,46020,363349,515714,796888,227947,333225,831883,197754,705824,297919,1020555,975849,733485,362966,94748,13412,462625,21458,436423,64462,336813,836968,347869,722456,710447,512092,692224,735624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 250704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 250704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002342s ]