SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50940 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50940 [ RunTime:0.002569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (182129,64809,216176,950119,178977,96981,154215,394533,1032503,912184,1042321,682468,895674,920046,91198,359784,966381,139761,13000,368208,842799,538078,1004097,816981,506548,224037,326375,488944,398524,637903,722101,564315,229508,652778,573344,50109,219428,699409,143233,668213,660701,28000,793786,982271,760543,650089,819056,799895,143505,677028,657895,368037,327645,332646,643433,581734,374680,251100,605004,484406) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]