SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500512 LIMIT 1 [ RunTime:0.001493s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500512 [ RunTime:0.002594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (223266,706669,931803,493389,882794,449549,1004224,48256,12175,524563,454278,540123,255854,276631,552355,52903,1002091,56115,984476,930056,1042313,490891,237008,145560,604752,953719,333321,361691,431047,311279,810063,397131,977387,424398,69701,857142,318085,730013,614962,494988,94770,511341,617127,437116,936465,574204,46569,629630,289802,949492,930297,431031,304481,217737,1012197,519306,558878,141235,224497,705170) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]