SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040601 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040601 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (186818,693935,948144,63208,58211,554859,392238,320468,501348,303268,55232,284512,647646,459198,977597,216479,211571,967238,281300,585973,25621,736509,789932,590239,179648,310391,787671,1045017,1015197,1010392,926534,261257,1042418,341700,596104,743738,590335,333951,281601,119429,996082,32627,405066,774118,488219,761676,596434,648317,620230,618441,877686,811769,972914,868364,926407,636790,1008238,453428,592557,368629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002582s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001327s ]