SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001419s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562713 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562713 [ RunTime:0.002384s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (972743,368926,337608,505831,66453,454337,482759,431256,521983,315032,119909,742156,208492,206569,382750,219820,69711,495957,371675,801194,145147,507456,982919,328334,585365,40579,603735,1020222,261273,759160,411133,330171,328236,44925,213441,336029,183870,512329,756196,291534,296728,221247,688559,208740,324050,425335,551885,486297,321073,769014,754967,7321,424957,21608,412093,194383,482287,505523,672199,155227) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001952s ]