SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101065 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101065 [ RunTime:0.002424s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (780821,986345,500298,217945,498970,172854,200444,613628,771363,602331,995151,263044,343952,618317,414826,664257,498418,589503,454725,796806,1040107,438890,720829,105910,29021,112928,332193,283508,62244,235745,779041,800950,702571,506190,307893,522016,1045806,889669,928446,15952,929433,536297,1042017,6684,117218,597735,1016203,729560,739697,930137,344014,579238,42510,100283,464008,201384,1002108,168740,864761,755436) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101065 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101065 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]