SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 588844 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 588844 [ RunTime:0.004440s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421591,144742,652708,918370,783353,277555,360371,229220,928510,751252,417532,766183,22397,524957,664564,862668,303611,475050,819908,856864,741951,161617,77957,592332,104396,245698,921058,477945,179252,130283,346796,136808,615935,679566,60525,162665,194908,547390,445525,493273,604261,141129,701905,365728,244464,586478,327302,424757,163104,1001899,243806,789098,132386,135573,515722,929915,726100,125630,628705,293191) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 588844 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 588844 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]