SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43359 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43359 [ RunTime:0.002785s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324360,97036,663200,285083,691812,789502,685367,264877,783569,82639,1025430,275258,783476,518467,1024165,368305,762127,965770,653196,331468,397047,334007,481669,623163,527402,201525,551160,978765,977656,613186,833146,1017121,806168,1039531,633995,576034,953095,53358,634619,654991,724134,956729,810618,839067,947724,745729,953747,51072,894905,961686,170329,230265,74647,394545,921293,757646,176920,107230,334223,287786) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001576s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43359 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000854s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43359 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001388s ]