SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411435 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411435 [ RunTime:0.002032s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030050,406651,561564,508104,733284,341073,532307,178200,528965,410826,607037,458634,163008,866804,770259,978606,160249,422005,433587,898387,377252,777366,235980,187852,210415,388189,43956,820524,1008743,162367,577499,822731,215430,51340,931029,708077,17346,688204,460603,425499,140769,305288,963783,824392,170574,744591,1028953,115749,1047805,75381,756560,968151,411431,256362,422441,56302,1028465,861641,481430,1036894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002842s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411435 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411435 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006454s ]