SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111793 LIMIT 1 [ RunTime:0.001191s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111793 [ RunTime:0.003427s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (45720,861056,185063,224104,730251,242602,800103,174676,184447,414191,979967,266248,319088,716690,477003,284163,869245,399996,431684,438621,489464,697402,770291,448874,206415,734004,35180,454910,214194,938724,303851,881780,354357,360731,16820,984848,273667,547290,97333,406938,909696,159032,298954,707229,848226,19437,602004,363049,696887,533126,105628,895150,597227,517158,114456,703451,1016231,788226,379195,5315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111793 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111793 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001019s ]