SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 180012 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 180012 [ RunTime:0.003449s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (754277,329651,861968,310350,197158,971470,899367,109639,817313,975514,123252,803886,899866,382214,1006806,405413,1008385,490391,862756,322916,309350,284726,841731,798667,533448,76262,434979,819785,467571,789037,942721,305094,4456,763689,199987,884962,256745,126063,171714,99686,686839,134584,826017,280289,553356,179344,176075,66694,347196,411041,223038,396409,835283,634972,847723,595519,894791,429973,572477,1014189) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 180012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 180012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000754s ]