SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536451 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536451 [ RunTime:0.003067s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (890803,787066,246707,921070,880443,816616,274321,354364,754879,483808,350389,431485,578587,409485,727075,397493,100414,157740,798161,133696,560372,153184,581705,652440,944821,77320,664851,517902,545575,579216,300637,367446,798508,537713,400387,450230,635195,268016,221610,742478,139167,379040,554878,863615,50107,227940,1009431,710800,112614,413613,29101,217685,262985,618588,556678,258902,170126,631127,867963,809233) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]