SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107041 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107041 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340268,247144,949940,1029362,751242,936821,232012,563817,41127,959925,267652,609058,622126,802276,132103,635239,1022256,917342,109299,454864,246608,105120,934632,510534,817590,272148,18951,513298,509835,991486,764827,716196,488240,711366,917049,717071,959142,993517,308570,1674,311301,500995,888954,996209,993252,961159,743298,988377,688300,798838,917971,710897,391562,489415,927074,13627,1018729,828889,1007571,826284) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]