SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1008393 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1008393 [ RunTime:0.001976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005972,418135,153801,402057,1022812,285481,854483,310129,194117,774094,336050,586379,148348,50521,977141,508547,945641,288259,261321,433378,302172,936939,973078,48923,744024,612228,1019777,495936,797703,114774,656073,676960,337502,340700,443972,185351,608309,753364,94986,217275,539789,38619,688573,877530,54895,713872,854882,1006805,66594,973321,791266,917014,280404,598612,17143,113603,962887,156368,403570,96180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1008393 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1008393 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001195s ]