SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014136 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014136 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313156,486501,199553,697466,998845,527179,242096,538724,196713,305049,541661,499736,479654,928134,997277,844968,764126,153668,725967,392506,128611,157587,911538,574689,1008149,229397,423838,138723,53898,575919,998021,278779,964854,303863,476790,622147,780911,127165,800889,96757,474266,946205,471265,442609,442316,1032154,346967,329776,566695,703154,639898,102666,818908,576354,641541,765390,605117,972611,570482,260764) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014136 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014136 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002553s ]