SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001411s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 272014 LIMIT 1 [ RunTime:0.000682s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 272014 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (19562,210799,76314,17491,751547,684364,788979,1017978,711038,585115,332321,369519,215661,741976,586197,111331,906495,919301,832969,376624,786652,286607,465072,320948,284347,650250,87534,633797,59498,682424,549120,489462,402940,337142,586555,368783,32412,447404,437639,252263,893526,272791,626095,377013,786648,1024089,958410,3165,668278,573172,567069,646057,696299,701322,753760,867237,692998,885882,888674,786267) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 272014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 272014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]