SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500843 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500843 [ RunTime:0.003357s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612147,264326,3684,343410,794701,941240,118607,150874,813918,287746,204728,314829,299409,324045,343182,555434,270131,430593,650407,83648,157183,534696,99456,330962,787242,897954,569963,275021,163513,408130,547408,456316,515030,783518,351316,799309,586838,650569,410477,401441,776374,950488,13471,916107,683800,526070,436718,297717,520974,1012029,282284,143777,162238,347309,377882,516948,652430,461932,645952,933499) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]