SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419321 LIMIT 1 [ RunTime:0.000511s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419321 [ RunTime:0.009711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (837324,417703,647000,1007011,560018,491103,765246,905452,824663,864731,987097,931498,469992,1028121,685940,700046,564119,30143,511808,86120,814178,836841,480002,184722,967652,217342,335519,630193,4057,852904,154035,167074,300468,816209,10974,295382,530626,461766,465011,606569,171268,840624,12869,683095,1022437,817923,250472,1003376,752749,581313,615273,872298,460016,51794,190317,1015681,765177,392149,337184,861151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001690s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419321 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419321 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000818s ]